Byway Trip Building Failed Trips

Dataset statistics

Number of variables	35
Number of observations	130
Missing cells	390
Missing cells (%)	8.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	33.0 KiB
Average record size in memory	260.0 B

Variable types

Numeric	11
Categorical	13
Text	2
DateTime	2
Unsupported	3
Boolean	4

Alerts

`aborteddataerrorcount` has constant value ""	Constant
`accommodationunavailableerrorcount` has constant value ""	Constant
`createtripformsubmission_directjourney` has constant value ""	Constant
`createtripformsubmission_extrainfo` has constant value ""	Constant
`failureindurationserrorcount` has constant value ""	Constant
`createtripformsubmission_fastjourney` has constant value ""	Constant
`overnightreductionerrorcount` has constant value ""	Constant
`success` has constant value ""	Constant
`transportunavailableerrorcount` is highly imbalanced (91.8%)	Imbalance
`creationdate` has 130 (100.0%) missing values	Missing
`jotform_onewaytrip` has 130 (100.0%) missing values	Missing
`tripbuildtimeseconds` has 130 (100.0%) missing values	Missing
`createtripid_region` has unique values	Unique
`creationdate` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`jotform_onewaytrip` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`tripbuildtimeseconds` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`badproportionerrorcount` has 87 (66.9%) zeros	Zeros
`firstchoiceaccommodationunavailablecount` has 89 (68.5%) zeros	Zeros
`noavailabledotwaccommodationerrorcount` has 99 (76.2%) zeros	Zeros
`nofamilymanualfallbackserrorcount` has 125 (96.2%) zeros	Zeros
`norouteserrorcount` has 46 (35.4%) zeros	Zeros
`substituteaccommodationunavailablecount` has 92 (70.8%) zeros	Zeros

Reproduction

Analysis started	2024-02-04 09:22:08.567431
Analysis finished	2024-02-04 09:22:20.706582
Duration	12.14 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

createtripid
Real number (ℝ)

Distinct	100
Distinct (%)	76.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6156834 × 10¹⁴

Minimum	6.0285046 × 10¹⁴
Maximum	9.1738366 × 10¹⁴
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.0 KiB

Quantile statistics

Minimum	6.0285046 × 10¹⁴
5-th percentile	6.1312692 × 10¹⁴
Q1	6.7532768 × 10¹⁴
median	7.6457361 × 10¹⁴
Q3	8.6002908 × 10¹⁴
95-th percentile	8.9916719 × 10¹⁴
Maximum	9.1738366 × 10¹⁴
Range	3.1453319 × 10¹⁴
Interquartile range (IQR)	1.847014 × 10¹⁴

Descriptive statistics

Standard deviation	9.7211611 × 10¹³
Coefficient of variation (CV)	0.1276466
Kurtosis	-1.3831741
Mean	7.6156834 × 10¹⁴
Median Absolute Deviation (MAD)	9.3034815 × 10¹³
Skewness	-0.016126638
Sum	9.9003884 × 10¹⁶
Variance	9.4500973 × 10²⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.129865837 × 10¹⁴	3	2.3%
8.878448985 × 10¹⁴	3	2.3%
9.148222706 × 10¹⁴	3	2.3%
8.603450218 × 10¹⁴	3	2.3%
6.325318859 × 10¹⁴	3	2.3%
8.699519905 × 10¹⁴	3	2.3%
7.743813566 × 10¹⁴	2	1.5%
8.645674085 × 10¹⁴	2	1.5%
8.492562173 × 10¹⁴	2	1.5%
8.847932007 × 10¹⁴	2	1.5%
Other values (90)	104	80.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.028504642 × 10¹⁴	1	0.8%
6.090115823 × 10¹⁴	1	0.8%
6.106867344 × 10¹⁴	1	0.8%
6.129865837 × 10¹⁴	3	2.3%
6.131269209 × 10¹⁴	2	1.5%
6.194806186 × 10¹⁴	1	0.8%
6.238749657 × 10¹⁴	2	1.5%
6.247531057 × 10¹⁴	1	0.8%
6.28563991 × 10¹⁴	1	0.8%
6.292823681 × 10¹⁴	1	0.8%

Value	Count	Frequency (%)
9.173836571 × 10¹⁴	1	0.8%
9.148222706 × 10¹⁴	3	2.3%
9.140777644 × 10¹⁴	1	0.8%
9.118122609 × 10¹⁴	1	0.8%
9.024857658 × 10¹⁴	1	0.8%
8.951111524 × 10¹⁴	2	1.5%
8.894085324 × 10¹⁴	1	0.8%
8.878448985 × 10¹⁴	3	2.3%
8.856509338 × 10¹⁴	1	0.8%
8.847932007 × 10¹⁴	2	1.5%

region
Categorical

Distinct	18
Distinct (%)	13.8%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

Yorkshire	42
Highlands & Islands	29
East Highlands	20
Andalusia	5
French Riviera	5
Other values (13)	29

Length

Max length	21
Median length	19
Mean length	12.653846
Min length	6

Characters and Unicode

Total characters	1645
Distinct characters	34
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	4.6%

Sample

1st row	Highlands & Islands
2nd row	Yorkshire
3rd row	Yorkshire
4th row	East Highlands
5th row	Andalusia

Common Values

Value	Count	Frequency (%)
Yorkshire	42	32.3%
Highlands & Islands	29	22.3%
East Highlands	20	15.4%
Andalusia	5	3.8%
French Riviera	5	3.8%
Catalonia	5	3.8%
Alsace	4	3.1%
Hauts-de-France	4	3.1%
Northern Italy	3	2.3%
Corsica	3	2.3%
Other values (8)	10	7.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
highlands	49	21.8%
yorkshire	42	18.7%
	31	13.8%
islands	29	12.9%
east	20	8.9%
riviera	6	2.7%
andalusia	5	2.2%
french	5	2.2%
catalonia	5	2.2%
hauts-de-france	4	1.8%
Other values (15)	29	12.9%

Most occurring characters

Value	Count	Frequency (%)
s	186	11.3%
a	159	9.7%
i	121	7.4%
r	118	7.2%
n	110	6.7%
l	106	6.4%
h	104	6.3%
	95	5.8%
d	89	5.4%
e	76	4.6%
Other values (24)	481	29.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1313	79.8%
Uppercase Letter	198	12.0%
Space Separator	95	5.8%
Other Punctuation	31	1.9%
Dash Punctuation	8	0.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	186	14.2%
a	159	12.1%
i	121	9.2%
r	118	9.0%
n	110	8.4%
l	106	8.1%
h	104	7.9%
d	89	6.8%
e	76	5.8%
o	59	4.5%
Other values (11)	185	14.1%

Uppercase Letter

Value	Count	Frequency (%)
H	53	26.8%
Y	42	21.2%
I	34	17.2%
E	20	10.1%
C	13	6.6%
A	9	4.5%
F	9	4.5%
R	7	3.5%
N	7	3.5%
S	4	2.0%

Space Separator

Value	Count	Frequency (%)
	95	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	31	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	8	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1511	91.9%
Common	134	8.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	186	12.3%
a	159	10.5%
i	121	8.0%
r	118	7.8%
n	110	7.3%
l	106	7.0%
h	104	6.9%
d	89	5.9%
e	76	5.0%
o	59	3.9%
Other values (21)	383	25.3%

Common

Value	Count	Frequency (%)
	95	70.9%
&	31	23.1%
-	8	6.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1645	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	186	11.3%
a	159	9.7%
i	121	7.4%
r	118	7.2%
n	110	6.7%
l	106	6.4%
h	104	6.3%
	95	5.8%
d	89	5.4%
e	76	4.6%
Other values (24)	481	29.2%

createtripid_region
Text

UNIQUE

Distinct	130
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

Length

Max length	37
Median length	35
Mean length	28.653846
Min length	22

Characters and Unicode

Total characters	3725
Distinct characters	45
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	130 ?
Unique (%)	100.0%

Sample

1st row	856446659120383_Highlands & Islands
2nd row	675305430969085_Yorkshire
3rd row	714914505173585_Yorkshire
4th row	619480618589444_East Highlands
5th row	687603529986566_Andalusia

Value	Count	Frequency (%)
	31	13.8%
islands	29	12.9%
highlands	20	8.9%
riviera	6	2.7%
italy	4	1.8%
spain	2	0.9%
central	2	0.9%
808561449369965_yorkshire	1	0.4%
764573606047540_east	1	0.4%
727428801083979_yorkshire	1	0.4%
Other values (128)	128	56.9%

Most occurring characters

Value	Count	Frequency (%)
6	238	6.4%
8	232	6.2%
4	203	5.4%
5	202	5.4%
2	189	5.1%
7	187	5.0%
s	186	5.0%
9	184	4.9%
0	175	4.7%
1	171	4.6%
Other values (35)	1758	47.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1950	52.3%
Lowercase Letter	1313	35.2%
Uppercase Letter	198	5.3%
Connector Punctuation	130	3.5%
Space Separator	95	2.6%
Other Punctuation	31	0.8%
Dash Punctuation	8	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	186	14.2%
a	159	12.1%
i	121	9.2%
r	118	9.0%
n	110	8.4%
l	106	8.1%
h	104	7.9%
d	89	6.8%
e	76	5.8%
o	59	4.5%
Other values (11)	185	14.1%

Decimal Number

Value	Count	Frequency (%)
6	238	12.2%
8	232	11.9%
4	203	10.4%
5	202	10.4%
2	189	9.7%
7	187	9.6%
9	184	9.4%
0	175	9.0%
1	171	8.8%
3	169	8.7%

Uppercase Letter

Value	Count	Frequency (%)
H	53	26.8%
Y	42	21.2%
I	34	17.2%
E	20	10.1%
C	13	6.6%
F	9	4.5%
A	9	4.5%
R	7	3.5%
N	7	3.5%
S	4	2.0%

Connector Punctuation

Value	Count	Frequency (%)
_	130	100.0%

Space Separator

Value	Count	Frequency (%)
	95	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	31	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	8	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2214	59.4%
Latin	1511	40.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	186	12.3%
a	159	10.5%
i	121	8.0%
r	118	7.8%
n	110	7.3%
l	106	7.0%
h	104	6.9%
d	89	5.9%
e	76	5.0%
o	59	3.9%
Other values (21)	383	25.3%

Common

Value	Count	Frequency (%)
6	238	10.7%
8	232	10.5%
4	203	9.2%
5	202	9.1%
2	189	8.5%
7	187	8.4%
9	184	8.3%
0	175	7.9%
1	171	7.7%
3	169	7.6%
Other values (4)	264	11.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3725	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
6	238	6.4%
8	232	6.2%
4	203	5.4%
5	202	5.4%
2	189	5.1%
7	187	5.0%
s	186	5.0%
9	184	4.9%
0	175	4.7%
1	171	4.6%
Other values (35)	1758	47.2%

requestdate
Date

Distinct	100
Distinct (%)	76.9%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

Minimum	2024-01-20 10:45:24.467000
Maximum	2024-01-24 22:41:30.125000

Histogram

Histogram with fixed size bins (bins=50)

aborteddataerrorcount
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

0	130

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	130
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	130	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	130	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	130	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	130	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	130	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	130	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	130	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	130	100.0%

accommodationunavailableerrorcount
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

0	130

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	130
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	130	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	130	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	130	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	130	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	130	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	130	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	130	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	130	100.0%

createtripformsubmission_adultcount
Real number (ℝ)

Distinct	6
Distinct (%)	4.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.2076923

Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	4.55
Maximum	6
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.0543094
Coefficient of variation (CV)	0.47756174
Kurtosis	3.4965675
Mean	2.2076923
Median Absolute Deviation (MAD)	0
Skewness	1.7499756
Sum	287
Variance	1.1115683
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2	82	63.1%
1	23	17.7%
3	10	7.7%
4	8	6.2%
5	4	3.1%
6	3	2.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	23	17.7%
2	82	63.1%
3	10	7.7%
4	8	6.2%
5	4	3.1%
6	3	2.3%

Value	Count	Frequency (%)
6	3	2.3%
5	4	3.1%
4	8	6.2%
3	10	7.7%
2	82	63.1%
1	23	17.7%

badproportionerrorcount
Real number (ℝ)

ZEROS

Distinct	27
Distinct (%)	20.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9

Minimum	0
Maximum	88
Zeros	87
Zeros (%)	66.9%
Negative	0
Negative (%)	0.0%
Memory size	2.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	11.75
95-th percentile	43.55
Maximum	88
Range	88
Interquartile range (IQR)	11.75

Descriptive statistics

Standard deviation	18.534694
Coefficient of variation (CV)	2.0594105
Kurtosis	7.1677848
Mean	9
Median Absolute Deviation (MAD)	0
Skewness	2.6172715
Sum	1170
Variance	343.53488
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
0	87	66.9%
14	4	3.1%
2	4	3.1%
40	3	2.3%
37	2	1.5%
48	2	1.5%
28	2	1.5%
13	2	1.5%
18	2	1.5%
30	2	1.5%
Other values (17)	20	15.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	87	66.9%
1	1	0.8%
2	4	3.1%
3	1	0.8%
4	1	0.8%
6	1	0.8%
10	1	0.8%
11	1	0.8%
12	1	0.8%
13	2	1.5%

Value	Count	Frequency (%)
88	1	0.8%
86	2	1.5%
80	1	0.8%
48	2	1.5%
44	1	0.8%
43	1	0.8%
42	1	0.8%
40	3	2.3%
37	2	1.5%
30	2	1.5%

createtripformsubmission_childages
Categorical

Distinct	20
Distinct (%)	15.4%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

{}	84
{13}	6
{15}	5
{14}	5
{9,13}	4
Other values (15)	26

Length

Max length	12
Median length	2
Mean length	3.3846154
Min length	2

Characters and Unicode

Total characters	440
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	5.4%

Sample

1st row	{}
2nd row	{7}
3rd row	{}
4th row	{}
5th row	{}

Common Values

Value	Count	Frequency (%)
{}	84	64.6%
{13}	6	4.6%
{15}	5	3.8%
{14}	5	3.8%
{9,13}	4	3.1%
{7,5}	3	2.3%
{12,12,15}	3	2.3%
{12,8}	3	2.3%
{13,10,10,7}	2	1.5%
{11,13}	2	1.5%
Other values (10)	13	10.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	84	64.6%
13	6	4.6%
15	5	3.8%
14	5	3.8%
9,13	4	3.1%
7,5	3	2.3%
12,12,15	3	2.3%
12,8	3	2.3%
7,8	2	1.5%
14,13	2	1.5%
Other values (10)	13	10.0%

Most occurring characters

Value	Count	Frequency (%)
{	130	29.5%
}	130	29.5%
1	59	13.4%
,	39	8.9%
3	18	4.1%
5	17	3.9%
7	11	2.5%
2	9	2.0%
9	8	1.8%
4	7	1.6%
Other values (3)	12	2.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	141	32.0%
Open Punctuation	130	29.5%
Close Punctuation	130	29.5%
Other Punctuation	39	8.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	59	41.8%
3	18	12.8%
5	17	12.1%
7	11	7.8%
2	9	6.4%
9	8	5.7%
4	7	5.0%
8	6	4.3%
0	5	3.5%
6	1	0.7%

Open Punctuation

Value	Count	Frequency (%)
{	130	100.0%

Close Punctuation

Value	Count	Frequency (%)
}	130	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	39	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	440	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
{	130	29.5%
}	130	29.5%
1	59	13.4%
,	39	8.9%
3	18	4.1%
5	17	3.9%
7	11	2.5%
2	9	2.0%
9	8	1.8%
4	7	1.6%
Other values (3)	12	2.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	440	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
{	130	29.5%
}	130	29.5%
1	59	13.4%
,	39	8.9%
3	18	4.1%
5	17	3.9%
7	11	2.5%
2	9	2.0%
9	8	1.8%
4	7	1.6%
Other values (3)	12	2.7%

createtripformsubmission_childcount
Categorical

Distinct	5
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

0	84
1	19
2	17
3	8
4	2

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	130
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	84	64.6%
1	19	14.6%
2	17	13.1%
3	8	6.2%
4	2	1.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	84	64.6%
1	19	14.6%
2	17	13.1%
3	8	6.2%
4	2	1.5%

Most occurring characters

Value	Count	Frequency (%)
0	84	64.6%
1	19	14.6%
2	17	13.1%
3	8	6.2%
4	2	1.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	130	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	84	64.6%
1	19	14.6%
2	17	13.1%
3	8	6.2%
4	2	1.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	130	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	84	64.6%
1	19	14.6%
2	17	13.1%
3	8	6.2%
4	2	1.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	84	64.6%
1	19	14.6%
2	17	13.1%
3	8	6.2%
4	2	1.5%

createtripformsubmission_closestcity_id
Real number (ℝ)

Distinct	20
Distinct (%)	15.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	87791889

Minimum	26
Maximum	8.3489087 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.0 KiB

Quantile statistics

Minimum	26
5-th percentile	26
Q1	26
median	26
Q3	22387470
95-th percentile	6.357787 × 10⁸
Maximum	8.3489087 × 10⁸
Range	8.3489084 × 10⁸
Interquartile range (IQR)	22387444

Descriptive statistics

Standard deviation	2.0329636 × 10⁸
Coefficient of variation (CV)	2.3156622
Kurtosis	7.5007007
Mean	87791889
Median Absolute Deviation (MAD)	0
Skewness	2.8385321
Sum	1.1412946 × 10¹⁰
Variance	4.1329409 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
26	70	53.8%
29	7	5.4%
156763922	6	4.6%
22376242	6	4.6%
833158856	5	3.8%
34	5	3.8%
394536297	4	3.1%
3117	4	3.1%
183936590	4	3.1%
306452460	4	3.1%
Other values (10)	15	11.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
26	70	53.8%
29	7	5.4%
34	5	3.8%
3117	4	3.1%
22371672	1	0.8%
22371813	2	1.5%
22371835	1	0.8%
22371862	1	0.8%
22376242	6	4.6%
22391212	1	0.8%

Value	Count	Frequency (%)
834890871	1	0.8%
834890865	1	0.8%
833158856	5	3.8%
394536297	4	3.1%
375285198	1	0.8%
306452460	4	3.1%
183936590	4	3.1%
156763922	6	4.6%
108321288	3	2.3%
42771065	3	2.3%

createtripformsubmission_closestcity
Categorical

Distinct	20
Distinct (%)	15.4%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

London	70
Bristol	7
Cambridge	6
Brighton	6
Coventry	5
Other values (15)	36

Length

Max length	17
Median length	6
Mean length	7.0461538
Min length	4

Characters and Unicode

Total characters	916
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	5.4%

Sample

1st row	Coventry
2nd row	London
3rd row	London
4th row	Chelmsford
5th row	London

Common Values

Value	Count	Frequency (%)
London	70	53.8%
Bristol	7	5.4%
Cambridge	6	4.6%
Brighton	6	4.6%
Coventry	5	3.8%
Manchester	5	3.8%
Guildford	4	3.1%
Bath	4	3.1%
Cardiff	4	3.1%
Chelmsford	4	3.1%
Other values (10)	15	11.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
london	70	52.2%
bristol	7	5.2%
cambridge	6	4.5%
brighton	6	4.5%
coventry	5	3.7%
manchester	5	3.7%
guildford	4	3.0%
bath	4	3.0%
cardiff	4	3.0%
chelmsford	4	3.0%
Other values (12)	19	14.2%

Most occurring characters

Value	Count	Frequency (%)
o	176	19.2%
n	159	17.4%
d	99	10.8%
L	76	8.3%
r	53	5.8%
e	41	4.5%
i	36	3.9%
t	35	3.8%
h	27	2.9%
s	25	2.7%
Other values (23)	189	20.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	776	84.7%
Uppercase Letter	134	14.6%
Space Separator	4	0.4%
Other Punctuation	2	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	176	22.7%
n	159	20.5%
d	99	12.8%
r	53	6.8%
e	41	5.3%
i	36	4.6%
t	35	4.5%
h	27	3.5%
s	25	3.2%
a	23	3.0%
Other values (11)	102	13.1%

Uppercase Letter

Value	Count	Frequency (%)
L	76	56.7%
C	21	15.7%
B	17	12.7%
M	5	3.7%
G	4	3.0%
A	3	2.2%
E	3	2.2%
S	2	1.5%
D	2	1.5%
P	1	0.7%

Space Separator

Value	Count	Frequency (%)
	4	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	910	99.3%
Common	6	0.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	176	19.3%
n	159	17.5%
d	99	10.9%
L	76	8.4%
r	53	5.8%
e	41	4.5%
i	36	4.0%
t	35	3.8%
h	27	3.0%
s	25	2.7%
Other values (21)	183	20.1%

Common

Value	Count	Frequency (%)
	4	66.7%
'	2	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	916	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	176	19.2%
n	159	17.4%
d	99	10.8%
L	76	8.3%
r	53	5.8%
e	41	4.5%
i	36	3.9%
t	35	3.8%
h	27	2.9%
s	25	2.7%
Other values (23)	189	20.6%

creationdate
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	130
Missing (%)	100.0%
Memory size	2.0 KiB

createtripformsubmission_directjourney
Boolean

CONSTANT

Distinct	1
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	1.1 KiB

False	130

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	130	100.0%

createtripformsubmission_durationdays
Real number (ℝ)

Distinct	12
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.2615385

Minimum	3
Maximum	25
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.0 KiB

Quantile statistics

Minimum	3
5-th percentile	3
Q1	3
median	7
Q3	7
95-th percentile	14
Maximum	25
Range	22
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.5732725
Coefficient of variation (CV)	0.57067006
Kurtosis	7.0734293
Mean	6.2615385
Median Absolute Deviation (MAD)	2
Skewness	2.1037604
Sum	814
Variance	12.768277
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	52	40.0%
3	41	31.5%
5	8	6.2%
4	7	5.4%
14	7	5.4%
10	5	3.8%
6	4	3.1%
12	2	1.5%
9	1	0.8%
25	1	0.8%
Other values (2)	2	1.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	41	31.5%
4	7	5.4%
5	8	6.2%
6	4	3.1%
7	52	40.0%
8	1	0.8%
9	1	0.8%
10	5	3.8%
12	2	1.5%
14	7	5.4%

Value	Count	Frequency (%)
25	1	0.8%
21	1	0.8%
14	7	5.4%
12	2	1.5%
10	5	3.8%
9	1	0.8%
8	1	0.8%
7	52	40.0%
6	4	3.1%
5	8	6.2%

array_to_string
Text

Distinct	76
Distinct (%)	58.5%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

Length

Max length	81
Median length	52
Mean length	35.2
Min length	3

Characters and Unicode

Total characters	4576
Distinct characters	28
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	43 ?
Unique (%)	33.1%

Sample

1st row	Relaxation,History
2nd row	Nature,Good for kids
3rd row	Nature,Food and Drink,History,Arts and Culture
4th row	History,Food and Drink,Nature
5th row	Arts and Culture,History,Food and Drink,Relaxation,Nature

Value	Count	Frequency (%)
and	103	25.1%
for	37	9.0%
good	21	5.1%
drink,nature	19	4.6%
arts	15	3.7%
drink	14	3.4%
kids	14	3.4%
relaxation,food	10	2.4%
relaxation,history,food	10	2.4%
culture	9	2.2%
Other values (75)	158	38.5%

Most occurring characters

Value	Count	Frequency (%)
o	398	8.7%
r	394	8.6%
t	364	8.0%
a	344	7.5%
,	308	6.7%
n	290	6.3%
e	289	6.3%
d	286	6.2%
	280	6.1%
i	266	5.8%
Other values (18)	1357	29.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3451	75.4%
Uppercase Letter	537	11.7%
Other Punctuation	308	6.7%
Space Separator	280	6.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	398	11.5%
r	394	11.4%
t	364	10.5%
a	344	10.0%
n	290	8.4%
e	289	8.4%
d	286	8.3%
i	266	7.7%
u	208	6.0%
s	153	4.4%
Other values (8)	459	13.3%

Uppercase Letter

Value	Count	Frequency (%)
N	102	19.0%
H	81	15.1%
A	76	14.2%
R	70	13.0%
D	68	12.7%
F	68	12.7%
G	37	6.9%
C	35	6.5%

Other Punctuation

Value	Count	Frequency (%)
,	308	100.0%

Space Separator

Value	Count	Frequency (%)
	280	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3988	87.2%
Common	588	12.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	398	10.0%
r	394	9.9%
t	364	9.1%
a	344	8.6%
n	290	7.3%
e	289	7.2%
d	286	7.2%
i	266	6.7%
u	208	5.2%
s	153	3.8%
Other values (16)	996	25.0%

Common

Value	Count	Frequency (%)
,	308	52.4%
	280	47.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4576	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	398	8.7%
r	394	8.6%
t	364	8.0%
a	344	7.5%
,	308	6.7%
n	290	6.3%
e	289	6.3%
d	286	6.2%
	280	6.1%
i	266	5.8%
Other values (18)	1357	29.7%

createtripformsubmission_extrainfo
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

{}	130

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	260
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	{}
2nd row	{}
3rd row	{}
4th row	{}
5th row	{}

Common Values

Value	Count	Frequency (%)
{}	130	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
	130	100.0%

Most occurring characters

Value	Count	Frequency (%)
{	130	50.0%
}	130	50.0%

Most occurring categories

Value	Count	Frequency (%)
Open Punctuation	130	50.0%
Close Punctuation	130	50.0%

Most frequent character per category

Open Punctuation

Value	Count	Frequency (%)
{	130	100.0%

Close Punctuation

Value	Count	Frequency (%)
}	130	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	260	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
{	130	50.0%
}	130	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	260	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
{	130	50.0%
}	130	50.0%

failtimeseconds
Real number (ℝ)

Distinct	127
Distinct (%)	97.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	593.91354

Minimum	2.65
Maximum	28218.37
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.0 KiB

Quantile statistics

Minimum	2.65
5-th percentile	4.2635
Q1	7.4425
median	27.725
Q3	61.03
95-th percentile	824.216
Maximum	28218.37
Range	28215.72
Interquartile range (IQR)	53.5875

Descriptive statistics

Standard deviation	3195.0613
Coefficient of variation (CV)	5.3796741
Kurtosis	53.573633
Mean	593.91354
Median Absolute Deviation (MAD)	21.27
Skewness	7.1194547
Sum	77208.76
Variance	10208416
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
31.2	2	1.5%
30.78	2	1.5%
6.83	2	1.5%
11.65	1	0.8%
5.32	1	0.8%
45.31	1	0.8%
21.65	1	0.8%
48.94	1	0.8%
2.87	1	0.8%
38.69	1	0.8%
Other values (117)	117	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.65	1	0.8%
2.87	1	0.8%
2.91	1	0.8%
3.26	1	0.8%
3.56	1	0.8%
3.93	1	0.8%
4.25	1	0.8%
4.28	1	0.8%
4.6	1	0.8%
4.64	1	0.8%

Value	Count	Frequency (%)
28218.37	1	0.8%
19266.32	1	0.8%
12860.31	1	0.8%
4860.36	1	0.8%
1260.54	1	0.8%
1041.07	1	0.8%
932.72	1	0.8%
691.6	1	0.8%
549.48	1	0.8%
542.18	1	0.8%

failureindurationserrorcount
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

0	130

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	130
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	130	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	130	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	130	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	130	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	130	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	130	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	130	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	130	100.0%

createtripformsubmission_fastjourney
Boolean

CONSTANT

Distinct	1
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	1.1 KiB

False	130

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	130	100.0%

firstchoiceaccommodationunavailablecount
Real number (ℝ)

ZEROS

Distinct	29
Distinct (%)	22.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26.184615

Minimum	0
Maximum	396
Zeros	89
Zeros (%)	68.5%
Negative	0
Negative (%)	0.0%
Memory size	2.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	217.9
Maximum	396
Range	396
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	76.138774
Coefficient of variation (CV)	2.9077675
Kurtosis	10.556768
Mean	26.184615
Median Absolute Deviation (MAD)	0
Skewness	3.3405439
Sum	3404
Variance	5797.1129
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
0	89	68.5%
1	9	6.9%
25	3	2.3%
18	2	1.5%
338	2	1.5%
12	2	1.5%
44	1	0.8%
15	1	0.8%
294	1	0.8%
80	1	0.8%
Other values (19)	19	14.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	89	68.5%
1	9	6.9%
2	1	0.8%
4	1	0.8%
5	1	0.8%
6	1	0.8%
9	1	0.8%
10	1	0.8%
11	1	0.8%
12	2	1.5%

Value	Count	Frequency (%)
396	1	0.8%
338	2	1.5%
314	1	0.8%
294	1	0.8%
258	1	0.8%
226	1	0.8%
208	1	0.8%
182	1	0.8%
170	1	0.8%
122	1	0.8%

noavailabledotwaccommodationerrorcount
Real number (ℝ)

ZEROS

Distinct	25
Distinct (%)	19.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	74.746154

Minimum	0
Maximum	1118
Zeros	99
Zeros (%)	76.2%
Negative	0
Negative (%)	0.0%
Memory size	2.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	694.75
Maximum	1118
Range	1118
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	220.63679
Coefficient of variation (CV)	2.9518147
Kurtosis	9.2028072
Mean	74.746154
Median Absolute Deviation (MAD)	0
Skewness	3.1820798
Sum	9717
Variance	48680.594
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
0	99	76.2%
1	6	4.6%
48	2	1.5%
55	2	1.5%
110	1	0.8%
28	1	0.8%
792	1	0.8%
348	1	0.8%
98	1	0.8%
811	1	0.8%
Other values (15)	15	11.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	99	76.2%
1	6	4.6%
2	1	0.8%
12	1	0.8%
28	1	0.8%
48	2	1.5%
55	2	1.5%
56	1	0.8%
98	1	0.8%
110	1	0.8%

Value	Count	Frequency (%)
1118	1	0.8%
920	1	0.8%
919	1	0.8%
846	1	0.8%
811	1	0.8%
792	1	0.8%
706	1	0.8%
681	1	0.8%
622	1	0.8%
581	1	0.8%

nofamilymanualfallbackserrorcount
Real number (ℝ)

ZEROS

Distinct	6
Distinct (%)	4.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5076923

Minimum	0
Maximum	62
Zeros	125
Zeros (%)	96.2%
Negative	0
Negative (%)	0.0%
Memory size	2.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	62
Range	62
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	8.2558376
Coefficient of variation (CV)	5.4758107
Kurtosis	35.074198
Mean	1.5076923
Median Absolute Deviation (MAD)	0
Skewness	5.8626267
Sum	196
Variance	68.158855
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	125	96.2%
62	1	0.8%
38	1	0.8%
50	1	0.8%
12	1	0.8%
34	1	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	125	96.2%
12	1	0.8%
34	1	0.8%
38	1	0.8%
50	1	0.8%
62	1	0.8%

Value	Count	Frequency (%)
62	1	0.8%
50	1	0.8%
38	1	0.8%
34	1	0.8%
12	1	0.8%
0	125	96.2%

nogoodscoreerrorcount
Categorical

Distinct	4
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

0	73
1	38
2	18
4	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	130
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.8%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	0
5th row	1

Common Values

Value	Count	Frequency (%)
0	73	56.2%
1	38	29.2%
2	18	13.8%
4	1	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	73	56.2%
1	38	29.2%
2	18	13.8%
4	1	0.8%

Most occurring characters

Value	Count	Frequency (%)
0	73	56.2%
1	38	29.2%
2	18	13.8%
4	1	0.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	130	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	73	56.2%
1	38	29.2%
2	18	13.8%
4	1	0.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	130	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	73	56.2%
1	38	29.2%
2	18	13.8%
4	1	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	73	56.2%
1	38	29.2%
2	18	13.8%
4	1	0.8%

norouteserrorcount
Real number (ℝ)

ZEROS

Distinct	26
Distinct (%)	20.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.0615385

Minimum	0
Maximum	134
Zeros	46
Zeros (%)	35.4%
Negative	0
Negative (%)	0.0%
Memory size	2.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	8.75
95-th percentile	41.1
Maximum	134
Range	134
Interquartile range (IQR)	8.75

Descriptive statistics

Standard deviation	21.448967
Coefficient of variation (CV)	2.3670337
Kurtosis	17.411728
Mean	9.0615385
Median Absolute Deviation (MAD)	2
Skewness	4.0250347
Sum	1178
Variance	460.0582
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
0	46	35.4%
1	14	10.8%
2	13	10.0%
9	9	6.9%
3	7	5.4%
14	5	3.8%
4	5	3.8%
7	4	3.1%
6	4	3.1%
10	3	2.3%
Other values (16)	20	15.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	46	35.4%
1	14	10.8%
2	13	10.0%
3	7	5.4%
4	5	3.8%
5	2	1.5%
6	4	3.1%
7	4	3.1%
8	2	1.5%
9	9	6.9%

Value	Count	Frequency (%)
134	1	0.8%
120	1	0.8%
100	1	0.8%
93	1	0.8%
65	1	0.8%
60	1	0.8%
42	1	0.8%
40	1	0.8%
38	1	0.8%
36	1	0.8%

jotform_onewaytrip
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	130
Missing (%)	100.0%
Memory size	2.0 KiB

overnightreductionerrorcount
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

0	130

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	130
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	130	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	130	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	130	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	130	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	130	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	130	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	130	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	130	100.0%

createtripformsubmission_preferreddate
Date

Distinct	66
Distinct (%)	50.8%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

Minimum	2024-02-10 00:00:00
Maximum	2025-10-29 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

createtripformsubmission_roomcount
Categorical

Distinct	5
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

1	94
3	16
2	15
6	3
4	2

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	130
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	94	72.3%
3	16	12.3%
2	15	11.5%
6	3	2.3%
4	2	1.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	94	72.3%
3	16	12.3%
2	15	11.5%
6	3	2.3%
4	2	1.5%

Most occurring characters

Value	Count	Frequency (%)
1	94	72.3%
3	16	12.3%
2	15	11.5%
6	3	2.3%
4	2	1.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	130	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	94	72.3%
3	16	12.3%
2	15	11.5%
6	3	2.3%
4	2	1.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	130	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	94	72.3%
3	16	12.3%
2	15	11.5%
6	3	2.3%
4	2	1.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	94	72.3%
3	16	12.3%
2	15	11.5%
6	3	2.3%
4	2	1.5%

substituteaccommodationunavailablecount
Real number (ℝ)

ZEROS

Distinct	29
Distinct (%)	22.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26.161538

Minimum	0
Maximum	396
Zeros	92
Zeros (%)	70.8%
Negative	0
Negative (%)	0.0%
Memory size	2.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	217.9
Maximum	396
Range	396
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	76.146615
Coefficient of variation (CV)	2.9106322
Kurtosis	10.555381
Mean	26.161538
Median Absolute Deviation (MAD)	0
Skewness	3.3403295
Sum	3401
Variance	5798.307
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
0	92	70.8%
1	6	4.6%
25	3	2.3%
18	2	1.5%
338	2	1.5%
12	2	1.5%
44	1	0.8%
15	1	0.8%
294	1	0.8%
80	1	0.8%
Other values (19)	19	14.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	92	70.8%
1	6	4.6%
2	1	0.8%
4	1	0.8%
5	1	0.8%
6	1	0.8%
9	1	0.8%
10	1	0.8%
11	1	0.8%
12	2	1.5%

Value	Count	Frequency (%)
396	1	0.8%
338	2	1.5%
314	1	0.8%
294	1	0.8%
258	1	0.8%
226	1	0.8%
208	1	0.8%
182	1	0.8%
170	1	0.8%
122	1	0.8%

success
Boolean

CONSTANT

Distinct	1
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	1.1 KiB

False	130

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	130	100.0%

timeouterrorcount
Categorical

Distinct	3
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

0	87
1	33
2	10

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	130
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	87	66.9%
1	33	25.4%
2	10	7.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	87	66.9%
1	33	25.4%
2	10	7.7%

Most occurring characters

Value	Count	Frequency (%)
0	87	66.9%
1	33	25.4%
2	10	7.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	130	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	87	66.9%
1	33	25.4%
2	10	7.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	130	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	87	66.9%
1	33	25.4%
2	10	7.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	87	66.9%
1	33	25.4%
2	10	7.7%

transportunavailableerrorcount
Categorical

IMBALANCE

Distinct	3
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

0	128
2	1
1	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	130
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	1.5%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	128	98.5%
2	1	0.8%
1	1	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	128	98.5%
2	1	0.8%
1	1	0.8%

Most occurring characters

Value	Count	Frequency (%)
0	128	98.5%
2	1	0.8%
1	1	0.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	130	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	128	98.5%
2	1	0.8%
1	1	0.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	130	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	128	98.5%
2	1	0.8%
1	1	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	128	98.5%
2	1	0.8%
1	1	0.8%

tripbuildtimeseconds
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	130
Missing (%)	100.0%
Memory size	2.0 KiB

createtripformsubmission_twinroompreferred
Boolean

Distinct	2
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	1.1 KiB

False	114
True	16

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	114	87.7%
True	16	12.3%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	createtripid	region	createtripid_region	requestdate	createtripformsubmission_adultcount	badproportionerrorcount	createtripformsubmission_childages	createtripformsubmission_childcount	createtripformsubmission_closestcity_id	createtripformsubmission_closestcity	creationdate	createtripformsubmission_directjourney	createtripformsubmission_durationdays	array_to_string	createtripformsubmission_extrainfo	failtimeseconds	createtripformsubmission_fastjourney	firstchoiceaccommodationunavailablecount	noavailabledotwaccommodationerrorcount	nogoodscoreerrorcount	norouteserrorcount	jotform_onewaytrip	createtripformsubmission_preferreddate	createtripformsubmission_roomcount	substituteaccommodationunavailablecount	success	timeouterrorcount	tripbuildtimeseconds	createtripformsubmission_twinroompreferred
2	856446659120383	Highlands & Islands	856446659120383_Highlands & Islands	2024-01-20 10:45:24.467	2	14	{}	0	833158856	Coventry	NaT	False	3	Relaxation,History	{}	11.65	False	1	1	1	9	NaN	2024-05-13	1	1	False	0	NaN	False
21	675305430969085	Yorkshire	675305430969085_Yorkshire	2024-01-20 11:14:28.218	2	0	{7}	1	26	London	NaT	False	4	Nature,Good for kids	{}	19266.32	False	0	0	0	2	NaN	2024-03-30	1	0	False	0	NaN	False
36	714914505173585	Yorkshire	714914505173585_Yorkshire	2024-01-20 11:23:33.937	2	0	{}	0	26	London	NaT	False	9	Nature,Food and Drink,History,Arts and Culture	{}	3.26	False	0	0	0	2	NaN	2024-05-23	1	0	False	0	NaN	False
53	619480618589444	East Highlands	619480618589444_East Highlands	2024-01-20 11:52:41.714	2	40	{}	0	306452460	Chelmsford	NaT	False	3	History,Food and Drink,Nature	{}	33.55	False	0	0	0	6	NaN	2024-03-16	1	0	False	1	NaN	False
80	687603529986566	Andalusia	687603529986566_Andalusia	2024-01-20 12:31:22.936	2	0	{}	0	26	London	NaT	False	7	Arts and Culture,History,Food and Drink,Relaxation,Nature	{}	28.92	False	0	0	1	0	NaN	2024-07-18	1	0	False	0	NaN	False
86	764573606047540	Highlands & Islands	764573606047540_Highlands & Islands	2024-01-20 12:39:01.236	2	3	{}	0	22376242	Brighton	NaT	False	4	Relaxation,Food and Drink	{}	15.80	False	0	0	0	0	NaN	2024-03-16	1	0	False	0	NaN	True
87	764573606047540	East Highlands	764573606047540_East Highlands	2024-01-20 12:39:01.236	2	2	{}	0	22376242	Brighton	NaT	False	4	Relaxation,Food and Drink	{}	11.84	False	0	0	0	0	NaN	2024-03-16	1	0	False	0	NaN	True
88	808561449369965	Yorkshire	808561449369965_Yorkshire	2024-01-20 12:40:42.367	2	0	{14}	1	26	London	NaT	False	6	Nature,History,Good for kids	{}	4.28	False	0	0	0	6	NaN	2024-03-28	1	0	False	0	NaN	False
92	727428801083979	Yorkshire	727428801083979_Yorkshire	2024-01-20 12:43:41.481	2	0	{14}	1	26	London	NaT	False	6	Nature,History	{}	5.48	False	0	0	0	5	NaN	2024-03-28	1	0	False	0	NaN	False
97	628563990972298	Yorkshire	628563990972298_Yorkshire	2024-01-20 12:45:58.307	2	0	{14}	1	26	London	NaT	False	6	Nature,Good for kids	{}	2.65	False	0	0	0	3	NaN	2024-03-28	1	0	False	0	NaN	False

	createtripid	region	createtripid_region	requestdate	createtripformsubmission_adultcount	badproportionerrorcount	createtripformsubmission_childages	createtripformsubmission_childcount	createtripformsubmission_closestcity_id	createtripformsubmission_closestcity	creationdate	createtripformsubmission_directjourney	createtripformsubmission_durationdays	array_to_string	createtripformsubmission_extrainfo	failtimeseconds	createtripformsubmission_fastjourney	firstchoiceaccommodationunavailablecount	noavailabledotwaccommodationerrorcount	nofamilymanualfallbackserrorcount	nogoodscoreerrorcount	norouteserrorcount	jotform_onewaytrip	createtripformsubmission_preferreddate	createtripformsubmission_roomcount	substituteaccommodationunavailablecount	success	timeouterrorcount	tripbuildtimeseconds	createtripformsubmission_twinroompreferred
4768	668413321135879	Highlands & Islands	668413321135879_Highlands & Islands	2024-01-24 18:53:49.287	2	0	{}	0	42771065	Liverpool	NaT	False	7	Arts and Culture,History,Food and Drink,Nature	{}	6.44	False	0	0	0	0	1	NaN	2024-07-18	1	0	False	0	NaN	False
4786	872823512594216	East Highlands	872823512594216_East Highlands	2024-01-24 19:39:49.435	2	28	{}	0	306452460	Chelmsford	NaT	False	3	Relaxation,Arts and Culture,Nature	{}	27.72	False	0	0	0	1	10	NaN	2024-03-20	1	0	False	0	NaN	False
4828	851628939291587	Yorkshire	851628939291587_Yorkshire	2024-01-24 20:32:53.935	2	0	{}	0	22371813	Exeter St David's	NaT	False	4	Arts and Culture,Relaxation,History,Food and Drink	{}	6.00	False	0	0	0	0	1	NaN	2025-03-03	1	0	False	0	NaN	True
4863	796306217429950	East Highlands	796306217429950_East Highlands	2024-01-24 21:06:30.856	2	88	{}	0	394536297	Guildford	NaT	False	3	nan	{}	69.99	False	0	0	0	0	10	NaN	2024-10-01	1	0	False	2	NaN	False
4864	796306217429950	Highlands & Islands	796306217429950_Highlands & Islands	2024-01-24 21:06:30.856	2	24	{}	0	394536297	Guildford	NaT	False	3	nan	{}	45.83	False	0	0	0	2	0	NaN	2024-10-01	1	0	False	0	NaN	False
4879	887844898490614	Hauts-de-France	887844898490614_Hauts-de-France	2024-01-24 21:19:07.318	2	0	{12,12,15}	3	26	London	NaT	False	7	Adventure,Good for kids	{}	142.92	False	294	792	0	1	0	NaN	2024-03-29	3	294	False	1	NaN	False
4880	887844898490614	Alsace	887844898490614_Alsace	2024-01-24 21:19:07.318	2	0	{12,12,15}	3	26	London	NaT	False	7	Adventure,Good for kids	{}	6.84	False	15	28	0	1	9	NaN	2024-03-29	3	15	False	0	NaN	False
4881	887844898490614	French Riviera	887844898490614_French Riviera	2024-01-24 21:19:07.318	2	0	{12,12,15}	3	26	London	NaT	False	7	Adventure,Good for kids	{}	259.56	False	170	581	34	1	36	NaN	2024-03-29	3	170	False	1	NaN	False
4933	727894810164352	Highlands & Islands	727894810164352_Highlands & Islands	2024-01-24 22:16:45.720	1	18	{15,15}	2	183936590	Cardiff	NaT	False	3	Food and Drink,Relaxation,History,Nature,Adventure	{}	14.64	False	1	1	0	1	11	NaN	2024-06-01	1	1	False	0	NaN	False
4941	902485765764024	Highlands & Islands	902485765764024_Highlands & Islands	2024-01-24 22:41:30.125	2	4	{}	0	22376242	Brighton	NaT	False	5	Relaxation,Nature	{}	23.25	False	0	0	0	0	0	NaN	2024-03-20	1	0	False	0	NaN	False

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Uppercase Letter

Connector Punctuation

Space Separator

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Open Punctuation

Close Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)